using System.Linq;
using System.Text;
using System.Diagnostics;
using System.Runtime.Serialization;
using System.Collections;
using System.Data;
using System.ComponentModel;
using System.Data.OracleClient;
using WPFExcelReport.Helpers;
using WPFExcelReport.Controls;
namespace WPFExcelReport
{
    public partial class VABJOUR
    {
        public DataRow Convert2ABJOUR(DataRow dwInput, string ITXDBVERSION, bool IsConvert = false)
        {
            DataSet SResult = new DataSet();
            SResult = QueryABJOUR(dwInput, 0);
            DataRow dwReturn = null;
            if (SResult.Tables[0].Rows.Count > 0)
            {
                dwReturn = SResult.Tables[0].Rows[0];
            }
            else
            {
                dwReturn = SResult.Tables[0].NewRow();
            }
            switch (ITXDBVERSION)
            {
                case "YGR":
                    #region=========
                    dwReturn["ABJKEY"] = " ".PadRight(0);
                    dwReturn["ABJMANDANT"] = " ".PadRight(2);
                    dwReturn["ABJAUFKRS"] = " ".PadRight(2);
                    dwReturn["ABJAUFLFD"] = " ".PadRight(6);
                    dwReturn["ABJAUFPOS"] = " ".PadRight(3);
                    dwReturn["ABJDATUM"] = " ".PadRight(0);
                    dwReturn["ABJZEIT"] = " ".PadRight(6);
                    dwReturn["ABJBENID"] = " ".PadRight(8);
                    dwReturn["ABJAPOS"] = " ".PadRight(4);
                    dwReturn["ABJAPOSLKZ"] = " ".PadRight(1);
                    dwReturn["ABJAFOLGE"] = " ".PadRight(3);
                    dwReturn["ABJAGANG"] = " ".PadRight(15);
                    dwReturn["ABJFILLER1"] = " ".PadRight(42);
                    dwReturn["ABJASTATUS"] = " ".PadRight(2);
                    dwReturn["ABJASPGRD"] = " ".PadRight(3);
                    dwReturn["ABJAKUNDNR"] = " ".PadRight(8);
                    dwReturn["ABJAWERK"] = " ".PadRight(3);
                    dwReturn["ABJAABT"] = " ".PadRight(3);
                    dwReturn["ABJAWAKZ"] = " ".PadRight(1);
                    dwReturn["ABJAART"] = " ".PadRight(20);
                    dwReturn["ABJAVAR"] = " ".PadRight(3);
                    dwReturn["ABJAFARBE"] = " ".PadRight(10);
                    dwReturn["ABJADESS"] = " ".PadRight(10);
                    dwReturn["ABJACOLORIT"] = " ".PadRight(10);
                    dwReturn["ABJABESCHICH"] = " ".PadRight(10);
                    dwReturn["ABJAZUSTAND"] = " ".PadRight(4);
                    dwReturn["ABJAGROE"] = " ".PadRight(7);
                    dwReturn["ABJASME"] = " ".PadRight(1);
                    dwReturn["ABJASOLLMENGE1"] = " ".PadRight(0);
                    dwReturn["ABJASOLLMENGE2"] = " ".PadRight(0);
                    dwReturn["ABJASOLLMENGE3"] = " ".PadRight(0);
                    dwReturn["ABJASOLLMENGE4"] = " ".PadRight(0);
                    dwReturn["ABJASOLLMENGE5"] = " ".PadRight(0);
                    dwReturn["ABJASOLLMENGE6"] = " ".PadRight(0);
                    dwReturn["ABJASOLLMENGE7"] = " ".PadRight(0);
                    dwReturn["ABJASOLLMENGE8"] = " ".PadRight(0);
                    dwReturn["ABJAVLLFM"] = " ".PadRight(0);
                    dwReturn["ABJAVLKG"] = " ".PadRight(0);
                    dwReturn["ABJAVLSTK"] = " ".PadRight(0);
                    dwReturn["ABJAEALFM"] = " ".PadRight(0);
                    dwReturn["ABJAEAKG"] = " ".PadRight(0);
                    dwReturn["ABJAEASTK"] = " ".PadRight(0);
                    dwReturn["ABJAEBLFM"] = " ".PadRight(0);
                    dwReturn["ABJAEBKG"] = " ".PadRight(0);
                    dwReturn["ABJAEBSTK"] = " ".PadRight(0);
                    dwReturn["ABJAABLFM"] = " ".PadRight(0);
                    dwReturn["ABJAABKG"] = " ".PadRight(0);
                    dwReturn["ABJAABSTK"] = " ".PadRight(0);
                    dwReturn["ABJAVSLFM"] = " ".PadRight(0);
                    dwReturn["ABJAVSKG"] = " ".PadRight(0);
                    dwReturn["ABJAVSSTK"] = " ".PadRight(0);
                    dwReturn["ABJARTLFM"] = " ".PadRight(0);
                    dwReturn["ABJARTKG"] = " ".PadRight(0);
                    dwReturn["ABJARTSTK"] = " ".PadRight(0);
                    dwReturn["ABJAANRKR"] = " ".PadRight(2);
                    dwReturn["ABJAALFDNR"] = " ".PadRight(6);
                    dwReturn["ABJAAFOLGEV"] = " ".PadRight(3);
                    dwReturn["ABJAAFOLGEB"] = " ".PadRight(3);
                    dwReturn["ABJAANRKR2"] = " ".PadRight(2);
                    dwReturn["ABJAALFDNR2"] = " ".PadRight(6);
                    dwReturn["ABJAAFOLGEV2"] = " ".PadRight(0);
                    dwReturn["ABJAAFOLGEB2"] = " ".PadRight(0);
                    dwReturn["ABJAANRKR3"] = " ".PadRight(2);
                    dwReturn["ABJAALFDNR3"] = " ".PadRight(6);
                    dwReturn["ABJAAFOLGEV3"] = " ".PadRight(0);
                    dwReturn["ABJAAFOLGEB3"] = " ".PadRight(0);
                    dwReturn["ABJAANRKR4"] = " ".PadRight(2);
                    dwReturn["ABJAALFDNR4"] = " ".PadRight(6);
                    dwReturn["ABJAAFOLGEV4"] = " ".PadRight(0);
                    dwReturn["ABJAAFOLGEB4"] = " ".PadRight(0);
                    dwReturn["ABJAVKAUFTYP"] = " ".PadRight(1);
                    dwReturn["ABJAVKAUFKRS"] = " ".PadRight(2);
                    dwReturn["ABJAVKAUFLFD"] = " ".PadRight(6);
                    dwReturn["ABJAVKAUFPOS"] = " ".PadRight(3);
                    dwReturn["ABJAVORMKZ"] = " ".PadRight(1);
                    dwReturn["ABJASANZSTK"] = " ".PadRight(0);
                    dwReturn["ABJASSTKLG"] = " ".PadRight(0);
                    dwReturn["ABJASSTKGEW"] = " ".PadRight(0);
                    dwReturn["ABJASSTKBRT"] = " ".PadRight(0);
                    dwReturn["ABJAGENDAT"] = " ".PadRight(0);
                    dwReturn["ABJAGENNR"] = " ".PadRight(12);
                    dwReturn["ABJAGENNAME"] = " ".PadRight(30);
                    dwReturn["ABJAGENWEG"] = " ".PadRight(2);
                    dwReturn["ABJFILLER2"] = " ".PadRight(74);
                    dwReturn["ABJNSTATUS"] = " ".PadRight(2);
                    dwReturn["ABJNSPGRD"] = " ".PadRight(3);
                    dwReturn["ABJNKUNDNR"] = " ".PadRight(8);
                    dwReturn["ABJNWERK"] = " ".PadRight(3);
                    dwReturn["ABJNABT"] = " ".PadRight(3);
                    dwReturn["ABJNWAKZ"] = " ".PadRight(1);
                    dwReturn["ABJNART"] = " ".PadRight(20);
                    dwReturn["ABJNVAR"] = " ".PadRight(3);
                    dwReturn["ABJNFARBE"] = " ".PadRight(10);
                    dwReturn["ABJNDESS"] = " ".PadRight(10);
                    dwReturn["ABJNCOLORIT"] = " ".PadRight(10);
                    dwReturn["ABJNBESCHICH"] = " ".PadRight(10);
                    dwReturn["ABJNZUSTAND"] = " ".PadRight(4);
                    dwReturn["ABJNGROE"] = " ".PadRight(7);
                    dwReturn["ABJNSME"] = " ".PadRight(1);
                    dwReturn["ABJNSOLLMENGE1"] = " ".PadRight(0);
                    dwReturn["ABJNSOLLMENGE2"] = " ".PadRight(0);
                    dwReturn["ABJNSOLLMENGE3"] = " ".PadRight(0);
                    dwReturn["ABJNSOLLMENGE4"] = " ".PadRight(0);
                    dwReturn["ABJNSOLLMENGE5"] = " ".PadRight(0);
                    dwReturn["ABJNSOLLMENGE6"] = " ".PadRight(0);
                    dwReturn["ABJNSOLLMENGE7"] = " ".PadRight(0);
                    dwReturn["ABJNSOLLMENGE8"] = " ".PadRight(0);
                    dwReturn["ABJNVLLFM"] = " ".PadRight(0);
                    dwReturn["ABJNVLKG"] = " ".PadRight(0);
                    dwReturn["ABJNVLSTK"] = " ".PadRight(0);
                    dwReturn["ABJNEALFM"] = " ".PadRight(0);
                    dwReturn["ABJNEAKG"] = " ".PadRight(0);
                    dwReturn["ABJNEASTK"] = " ".PadRight(0);
                    dwReturn["ABJNEBLFM"] = " ".PadRight(0);
                    dwReturn["ABJNEBKG"] = " ".PadRight(0);
                    dwReturn["ABJNEBSTK"] = " ".PadRight(0);
                    dwReturn["ABJNABLFM"] = " ".PadRight(0);
                    dwReturn["ABJNABKG"] = " ".PadRight(0);
                    dwReturn["ABJNABSTK"] = " ".PadRight(0);
                    dwReturn["ABJNVSLFM"] = " ".PadRight(0);
                    dwReturn["ABJNVSKG"] = " ".PadRight(0);
                    dwReturn["ABJNVSSTK"] = " ".PadRight(0);
                    dwReturn["ABJNRTLFM"] = " ".PadRight(0);
                    dwReturn["ABJNRTKG"] = " ".PadRight(0);
                    dwReturn["ABJNRTSTK"] = " ".PadRight(0);
                    dwReturn["ABJNANRKR"] = " ".PadRight(2);
                    dwReturn["ABJNALFDNR"] = " ".PadRight(6);
                    dwReturn["ABJNAFOLGEV"] = " ".PadRight(3);
                    dwReturn["ABJNAFOLGEB"] = " ".PadRight(3);
                    dwReturn["ABJNANRKR2"] = " ".PadRight(2);
                    dwReturn["ABJNALFDNR2"] = " ".PadRight(6);
                    dwReturn["ABJNAFOLGEV2"] = " ".PadRight(0);
                    dwReturn["ABJNAFOLGEB2"] = " ".PadRight(0);
                    dwReturn["ABJNANRKR3"] = " ".PadRight(2);
                    dwReturn["ABJNALFDNR3"] = " ".PadRight(6);
                    dwReturn["ABJNAFOLGEV3"] = " ".PadRight(0);
                    dwReturn["ABJNAFOLGEB3"] = " ".PadRight(0);
                    dwReturn["ABJNANRKR4"] = " ".PadRight(2);
                    dwReturn["ABJNALFDNR4"] = " ".PadRight(6);
                    dwReturn["ABJNAFOLGEV4"] = " ".PadRight(0);
                    dwReturn["ABJNAFOLGEB4"] = " ".PadRight(0);
                    dwReturn["ABJNVKAUFTYP"] = " ".PadRight(1);
                    dwReturn["ABJNVKAUFKRS"] = " ".PadRight(2);
                    dwReturn["ABJNVKAUFLFD"] = " ".PadRight(6);
                    dwReturn["ABJNVKAUFPOS"] = " ".PadRight(3);
                    dwReturn["ABJNVORMKZ"] = " ".PadRight(1);
                    dwReturn["ABJNSANZSTK"] = " ".PadRight(0);
                    dwReturn["ABJNSSTKLG"] = " ".PadRight(0);
                    dwReturn["ABJNSSTKGEW"] = " ".PadRight(0);
                    dwReturn["ABJNSSTKBRT"] = " ".PadRight(0);
                    dwReturn["ABJNGENDAT"] = " ".PadRight(0);
                    dwReturn["ABJNGENNR"] = " ".PadRight(12);
                    dwReturn["ABJNGENNAME"] = " ".PadRight(30);
                    dwReturn["ABJNGENWEG"] = " ".PadRight(2);
                    dwReturn["ABJFILLER3"] = " ".PadRight(74);
                    #endregion
                    break;
                case "JLT":

                    break;
                default:

                    break;
            }
            if (IsConvert)
            {
                foreach (DataColumn cm in dwInput.Table.Columns)
                {
                    if (dwInput[cm.ColumnName].ToString() == "")
                        continue;
                    if (dwReturn.Table.Columns.Contains(cm.ColumnName))
                    {
                        dwReturn[cm.ColumnName] = dwInput[cm.ColumnName];
                    }
                }
            }
            return dwReturn;
        }
        public void MapABJOUR(ref DataRow dwLocal, DataRow dwData)
        {
            BlindMap(ref dwLocal, dwData);
        }
        public void SaveABJOUR(DataRow dwData, string ITXDBVERSION = "50.24")
        {
            DataSet setResult = new DataSet();
            DataTable tbLocal = null;
            DataRow dwLocal = null;
            bool flgExist = false;
            setResult = QueryABJOUR(dwData);
            if (setResult.Tables.Count > 0)
            {
                tbLocal = setResult.Tables[0];
                if (tbLocal.Rows.Count > 0)
                {
                    flgExist = true;
                    dwLocal = tbLocal.Rows[0];
                }
                else
                {
                    dwLocal = tbLocal.NewRow();
                }
            }
            MapABJOUR(ref dwLocal, dwData);

            if (!flgExist)
            {

                InsertABJOUR(dwLocal, ITXDBVERSION);
            }
            UpdateABJOUR(dwLocal);
        }
        public void InsertABJOUR(DataRow dwData, string ITXDBVERSION = "50.24")
        {
           
            or1 = OracleDB.CreateCommand();
            switch (ITXDBVERSION)
            {
                case "YGR":
                    or1.CommandText = "INSERT INTO ABJOUR(VAKBMANDANT, VAKBKOLL, VAKBART, VAKBKUNDNR, VAKBFARBE, VAKBKDARTNR, VAKBKDARTBEZ, VAKBKDFARBNR, VAKBANDRUCK, VAKBMEGEW, VAKBMENGEH, VAKBGEWVON, VAKBGEWBIS, VAKBGEWCA, VAKBGEWFKT, VAKBGEWGRP, VAKBMEGFKT, VAKBMEGGRP, VAKBAENDZL, VAKBAENDBEN, VAKBAENDDAT, VAKBNEUBEN, VAKBNEUDAT, VAKBFILLER)"
                        + " VALUES (:VAKBMANDANT, :VAKBKOLL, :VAKBART, :VAKBKUNDNR, :VAKBFARBE, '                         ', '                         ', '                             ', ' ', '   ', '   ', 0, 0, ' ', '000000000000', ' ', '000000000000', ' ', 0, '        ', '000000', '        ', '      ', '                                          ')";
                    or1.Parameters.Add("VAKBMANDANT", OracleType.NVarChar).Value = dwData["VAKBMANDANT"].ToString();
                    or1.Parameters.Add("VAKBKOLL", OracleType.NVarChar).Value = dwData["VAKBKOLL"].ToString();
                    or1.Parameters.Add("VAKBART", OracleType.NVarChar).Value = dwData["VAKBART"].ToString();
                    or1.Parameters.Add("VAKBFARBE", OracleType.NVarChar).Value = dwData["VAKBFARBE"].ToString();
                    or1.Parameters.Add("VAKBKUNDNR", OracleType.NVarChar).Value = dwData["VAKBKUNDNR"].ToString();
                    break;
                    //VAFMANDANT VAFKOLL VAFART VAFFARBE VAFBEZ VAFFFARBE

            }

            Connect2Proxy(or1);
        }
        public DataSet QueryABJOUR(DataRow dwData, int option = 1)
        {
            DataSet Return;
            DataSet Result = new DataSet();
            OracleCommand or1 = OracleDB.CreateCommand();
            switch (option)
            {
                case 0:
                    or1.CommandText = "SELECT * FROM ABJOUR WHERE  ROWNUM<2 ";
                    break;
                case 1:
                    or1.CommandText = "select A.ABJAUFKRS||'-'||TO_NUMBER(A.ABJAUFLFD)||'-'||TO_NUMBER(A.ABJAUFPOS) AS ORDERNO, "
                        + " A.ABJDATUM,A.ABJBENID, TRIM(A.ABJAART)||'-'||TRIM(A.ABJAFARBE)AS ART,B.ABPZUGET*0.01 AS ALLQTY,C.AA AS QTY "
                        + " FROM ABJOUR A,ABPOS B, "
                        + " (select T1.TXTIMANDANT,TRIM(T1.TXTISIND) AS TXTISIND,TRIM(TXTKTEXT) AS AA from txtind T1,TXTKON T2  "
                        + " where T1.txtitxtart = 'ABJ' AND T1.TXTIMANDANT = T2.TXTKMANDANT "
                        + " AND T1.TXTIPIND = T2.TXTKPIND AND T2.TXTKPOS = '10') C  "
                        + " WHERE A.ABJMANDANT = B.ABPMANDANT AND A.ABJAUFKRS = B.ABPAUFKRS "
                        + " AND A.ABJAUFLFD = B.ABPAUFLFD AND A.ABJAUFPOS = B.ABPAUFPOS "
                        + " AND B.ABPAUFART ='VA' AND TRIM(A.ABJAGANG) = 'FN' "
                        + " AND C.TXTIMANDANT = A.ABJMANDANT AND C.TXTISIND = LPAD(A.ABJKEY,9,'0') "
                        + " AND A.ABJDATUM >='" + dwData["ABPNEUDAT"].ToString().Trim() + "' "
                        + " AND A.ABJDATUM <='" + dwData["ABPAENDDAT"].ToString().Trim() + "' "
                        + " AND TRIM(A.ABJAART)||'-'||TRIM(A.ABJAFARBE) LIKE '" + dwData["ABPART"].ToString().Trim() + "%' ";
                    break;
                case 99:
                    or1.CommandText = "SELECT * FROM ABJOUR  WHERE ROWNUM<50";
                    break;
                default:
                    break;
            }
            Result = Connect2Proxy(or1);
            if (Result.Tables.Count > 0)
                Result.Tables[0].TableName = "ABJOUR";
            Return = Result;
            return Return;
        }
        public void DeleteABJOUR(DataRow dwData, int option = 1)
        {

            OracleCommand or1 = OracleDB.CreateCommand();
            switch (option)
            {
                case 1:
                    or1.CommandText = "DELETE FROM ABJOUR   WHERE  VAKBMANDANT=:VAKBMANDANT AND VAKBKOLL=:VAKBKOLL AND VAKBART =:VAKBART AND VAKBFARBE=:VAKBFARBE AND VAKBKUNDNR=:VAKBKUNDNR";
                    or1.Parameters.Add("VAKBMANDANT", OracleType.NVarChar).Value = dwData["VAKBMANDANT"].ToString();
                    or1.Parameters.Add("VAKBKOLL", OracleType.NVarChar).Value = dwData["VAKBKOLL"].ToString();
                    or1.Parameters.Add("VAKBART", OracleType.NVarChar).Value = dwData["VAKBART"].ToString();
                    or1.Parameters.Add("VAKBFARBE", OracleType.NVarChar).Value = dwData["VAKBFARBE"].ToString();
                    or1.Parameters.Add("VAKBKUNDNR", OracleType.NVarChar).Value = dwData["VAKBKUNDNR"].ToString();
                    break;
                default:
                    break;
            }
            Connect2Proxy(or1);
        }

        public void UpdateABJOUR(DataRow dwData, string ITXDBVERSION = "50.24", int option = 1)
        {
            OracleCommand or1;
            DataSet Result = new DataSet();
            or1 = OracleDB.CreateCommand();
            switch (option)
            {
                case 1:
                    #region====Command==== 
                    or1.CommandText = "UPDATE ABJOUR SET "
                    + "ABJKEY= :ABJKEY,"
                    + "ABJMANDANT= :ABJMANDANT,"
                    + "ABJAUFKRS= :ABJAUFKRS,"
                    + "ABJAUFLFD= :ABJAUFLFD,"
                    + "ABJAUFPOS= :ABJAUFPOS,"
                    + "ABJDATUM= :ABJDATUM,"
                    + "ABJZEIT= :ABJZEIT,"
                    + "ABJBENID= :ABJBENID,"
                    + "ABJAPOS= :ABJAPOS,"
                    + "ABJAPOSLKZ= :ABJAPOSLKZ,"
                    + "ABJAFOLGE= :ABJAFOLGE,"
                    + "ABJAGANG= :ABJAGANG,"
                    + "ABJFILLER1= :ABJFILLER1,"
                    + "ABJASTATUS= :ABJASTATUS,"
                    + "ABJASPGRD= :ABJASPGRD,"
                    + "ABJAKUNDNR= :ABJAKUNDNR,"
                    + "ABJAWERK= :ABJAWERK,"
                    + "ABJAABT= :ABJAABT,"
                    + "ABJAWAKZ= :ABJAWAKZ,"
                    + "ABJAART= :ABJAART,"
                    + "ABJAVAR= :ABJAVAR,"
                    + "ABJAFARBE= :ABJAFARBE,"
                    + "ABJADESS= :ABJADESS,"
                    + "ABJACOLORIT= :ABJACOLORIT,"
                    + "ABJABESCHICH= :ABJABESCHICH,"
                    + "ABJAZUSTAND= :ABJAZUSTAND,"
                    + "ABJAGROE= :ABJAGROE,"
                    + "ABJASME= :ABJASME,"
                    + "ABJASOLLMENGE1= :ABJASOLLMENGE1,"
                    + "ABJASOLLMENGE2= :ABJASOLLMENGE2,"
                    + "ABJASOLLMENGE3= :ABJASOLLMENGE3,"
                    + "ABJASOLLMENGE4= :ABJASOLLMENGE4,"
                    + "ABJASOLLMENGE5= :ABJASOLLMENGE5,"
                    + "ABJASOLLMENGE6= :ABJASOLLMENGE6,"
                    + "ABJASOLLMENGE7= :ABJASOLLMENGE7,"
                    + "ABJASOLLMENGE8= :ABJASOLLMENGE8,"
                    + "ABJAVLLFM= :ABJAVLLFM,"
                    + "ABJAVLKG= :ABJAVLKG,"
                    + "ABJAVLSTK= :ABJAVLSTK,"
                    + "ABJAEALFM= :ABJAEALFM,"
                    + "ABJAEAKG= :ABJAEAKG,"
                    + "ABJAEASTK= :ABJAEASTK,"
                    + "ABJAEBLFM= :ABJAEBLFM,"
                    + "ABJAEBKG= :ABJAEBKG,"
                    + "ABJAEBSTK= :ABJAEBSTK,"
                    + "ABJAABLFM= :ABJAABLFM,"
                    + "ABJAABKG= :ABJAABKG,"
                    + "ABJAABSTK= :ABJAABSTK,"
                    + "ABJAVSLFM= :ABJAVSLFM,"
                    + "ABJAVSKG= :ABJAVSKG,"
                    + "ABJAVSSTK= :ABJAVSSTK,"
                    + "ABJARTLFM= :ABJARTLFM,"
                    + "ABJARTKG= :ABJARTKG,"
                    + "ABJARTSTK= :ABJARTSTK,"
                    + "ABJAANRKR= :ABJAANRKR,"
                    + "ABJAALFDNR= :ABJAALFDNR,"
                    + "ABJAAFOLGEV= :ABJAAFOLGEV,"
                    + "ABJAAFOLGEB= :ABJAAFOLGEB,"
                    + "ABJAANRKR2= :ABJAANRKR2,"
                    + "ABJAALFDNR2= :ABJAALFDNR2,"
                    + "ABJAAFOLGEV2= :ABJAAFOLGEV2,"
                    + "ABJAAFOLGEB2= :ABJAAFOLGEB2,"
                    + "ABJAANRKR3= :ABJAANRKR3,"
                    + "ABJAALFDNR3= :ABJAALFDNR3,"
                    + "ABJAAFOLGEV3= :ABJAAFOLGEV3,"
                    + "ABJAAFOLGEB3= :ABJAAFOLGEB3,"
                    + "ABJAANRKR4= :ABJAANRKR4,"
                    + "ABJAALFDNR4= :ABJAALFDNR4,"
                    + "ABJAAFOLGEV4= :ABJAAFOLGEV4,"
                    + "ABJAAFOLGEB4= :ABJAAFOLGEB4,"
                    + "ABJAVKAUFTYP= :ABJAVKAUFTYP,"
                    + "ABJAVKAUFKRS= :ABJAVKAUFKRS,"
                    + "ABJAVKAUFLFD= :ABJAVKAUFLFD,"
                    + "ABJAVKAUFPOS= :ABJAVKAUFPOS,"
                    + "ABJAVORMKZ= :ABJAVORMKZ,"
                    + "ABJASANZSTK= :ABJASANZSTK,"
                    + "ABJASSTKLG= :ABJASSTKLG,"
                    + "ABJASSTKGEW= :ABJASSTKGEW,"
                    + "ABJASSTKBRT= :ABJASSTKBRT,"
                    + "ABJAGENDAT= :ABJAGENDAT,"
                    + "ABJAGENNR= :ABJAGENNR,"
                    + "ABJAGENNAME= :ABJAGENNAME,"
                    + "ABJAGENWEG= :ABJAGENWEG,"
                    + "ABJFILLER2= :ABJFILLER2,"
                    + "ABJNSTATUS= :ABJNSTATUS,"
                    + "ABJNSPGRD= :ABJNSPGRD,"
                    + "ABJNKUNDNR= :ABJNKUNDNR,"
                    + "ABJNWERK= :ABJNWERK,"
                    + "ABJNABT= :ABJNABT,"
                    + "ABJNWAKZ= :ABJNWAKZ,"
                    + "ABJNART= :ABJNART,"
                    + "ABJNVAR= :ABJNVAR,"
                    + "ABJNFARBE= :ABJNFARBE,"
                    + "ABJNDESS= :ABJNDESS,"
                    + "ABJNCOLORIT= :ABJNCOLORIT,"
                    + "ABJNBESCHICH= :ABJNBESCHICH,"
                    + "ABJNZUSTAND= :ABJNZUSTAND,"
                    + "ABJNGROE= :ABJNGROE,"
                    + "ABJNSME= :ABJNSME,"
                    + "ABJNSOLLMENGE1= :ABJNSOLLMENGE1,"
                    + "ABJNSOLLMENGE2= :ABJNSOLLMENGE2,"
                    + "ABJNSOLLMENGE3= :ABJNSOLLMENGE3,"
                    + "ABJNSOLLMENGE4= :ABJNSOLLMENGE4,"
                    + "ABJNSOLLMENGE5= :ABJNSOLLMENGE5,"
                    + "ABJNSOLLMENGE6= :ABJNSOLLMENGE6,"
                    + "ABJNSOLLMENGE7= :ABJNSOLLMENGE7,"
                    + "ABJNSOLLMENGE8= :ABJNSOLLMENGE8,"
                    + "ABJNVLLFM= :ABJNVLLFM,"
                    + "ABJNVLKG= :ABJNVLKG,"
                    + "ABJNVLSTK= :ABJNVLSTK,"
                    + "ABJNEALFM= :ABJNEALFM,"
                    + "ABJNEAKG= :ABJNEAKG,"
                    + "ABJNEASTK= :ABJNEASTK,"
                    + "ABJNEBLFM= :ABJNEBLFM,"
                    + "ABJNEBKG= :ABJNEBKG,"
                    + "ABJNEBSTK= :ABJNEBSTK,"
                    + "ABJNABLFM= :ABJNABLFM,"
                    + "ABJNABKG= :ABJNABKG,"
                    + "ABJNABSTK= :ABJNABSTK,"
                    + "ABJNVSLFM= :ABJNVSLFM,"
                    + "ABJNVSKG= :ABJNVSKG,"
                    + "ABJNVSSTK= :ABJNVSSTK,"
                    + "ABJNRTLFM= :ABJNRTLFM,"
                    + "ABJNRTKG= :ABJNRTKG,"
                    + "ABJNRTSTK= :ABJNRTSTK,"
                    + "ABJNANRKR= :ABJNANRKR,"
                    + "ABJNALFDNR= :ABJNALFDNR,"
                    + "ABJNAFOLGEV= :ABJNAFOLGEV,"
                    + "ABJNAFOLGEB= :ABJNAFOLGEB,"
                    + "ABJNANRKR2= :ABJNANRKR2,"
                    + "ABJNALFDNR2= :ABJNALFDNR2,"
                    + "ABJNAFOLGEV2= :ABJNAFOLGEV2,"
                    + "ABJNAFOLGEB2= :ABJNAFOLGEB2,"
                    + "ABJNANRKR3= :ABJNANRKR3,"
                    + "ABJNALFDNR3= :ABJNALFDNR3,"
                    + "ABJNAFOLGEV3= :ABJNAFOLGEV3,"
                    + "ABJNAFOLGEB3= :ABJNAFOLGEB3,"
                    + "ABJNANRKR4= :ABJNANRKR4,"
                    + "ABJNALFDNR4= :ABJNALFDNR4,"
                    + "ABJNAFOLGEV4= :ABJNAFOLGEV4,"
                    + "ABJNAFOLGEB4= :ABJNAFOLGEB4,"
                    + "ABJNVKAUFTYP= :ABJNVKAUFTYP,"
                    + "ABJNVKAUFKRS= :ABJNVKAUFKRS,"
                    + "ABJNVKAUFLFD= :ABJNVKAUFLFD,"
                    + "ABJNVKAUFPOS= :ABJNVKAUFPOS,"
                    + "ABJNVORMKZ= :ABJNVORMKZ,"
                    + "ABJNSANZSTK= :ABJNSANZSTK,"
                    + "ABJNSSTKLG= :ABJNSSTKLG,"
                    + "ABJNSSTKGEW= :ABJNSSTKGEW,"
                    + "ABJNSSTKBRT= :ABJNSSTKBRT,"
                    + "ABJNGENDAT= :ABJNGENDAT,"
                    + "ABJNGENNR= :ABJNGENNR,"
                    + "ABJNGENNAME= :ABJNGENNAME,"
                    + "ABJNGENWEG= :ABJNGENWEG,"
                    + "ABJFILLER3= :ABJFILLER3,"
                        + " WHERE  "
                        + "  VAKBMANDANT=:VAKBMANDANT AND VAKBKOLL=:VAKBKOLL AND VAKBART =:VAKBART AND VAKBFARBE=:VAKBFARBE AND VAKBKUNDNR=:VAKBKUNDNR";
                    #endregion

                    #region====Parameters====
                    or1.Parameters.Add("ABJKEY", OracleType.NVarChar).Value = dwData["ABJKEY"].ToString();
                    or1.Parameters.Add("ABJMANDANT", OracleType.NVarChar).Value = dwData["ABJMANDANT"].ToString();
                    or1.Parameters.Add("ABJAUFKRS", OracleType.NVarChar).Value = dwData["ABJAUFKRS"].ToString();
                    or1.Parameters.Add("ABJAUFLFD", OracleType.NVarChar).Value = dwData["ABJAUFLFD"].ToString();
                    or1.Parameters.Add("ABJAUFPOS", OracleType.NVarChar).Value = dwData["ABJAUFPOS"].ToString();
                    or1.Parameters.Add("ABJDATUM", OracleType.NVarChar).Value = dwData["ABJDATUM"].ToString();
                    or1.Parameters.Add("ABJZEIT", OracleType.NVarChar).Value = dwData["ABJZEIT"].ToString();
                    or1.Parameters.Add("ABJBENID", OracleType.NVarChar).Value = dwData["ABJBENID"].ToString();
                    or1.Parameters.Add("ABJAPOS", OracleType.NVarChar).Value = dwData["ABJAPOS"].ToString();
                    or1.Parameters.Add("ABJAPOSLKZ", OracleType.NVarChar).Value = dwData["ABJAPOSLKZ"].ToString();
                    or1.Parameters.Add("ABJAFOLGE", OracleType.NVarChar).Value = dwData["ABJAFOLGE"].ToString();
                    or1.Parameters.Add("ABJAGANG", OracleType.NVarChar).Value = dwData["ABJAGANG"].ToString();
                    or1.Parameters.Add("ABJFILLER1", OracleType.NVarChar).Value = dwData["ABJFILLER1"].ToString();
                    or1.Parameters.Add("ABJASTATUS", OracleType.NVarChar).Value = dwData["ABJASTATUS"].ToString();
                    or1.Parameters.Add("ABJASPGRD", OracleType.NVarChar).Value = dwData["ABJASPGRD"].ToString();
                    or1.Parameters.Add("ABJAKUNDNR", OracleType.NVarChar).Value = dwData["ABJAKUNDNR"].ToString();
                    or1.Parameters.Add("ABJAWERK", OracleType.NVarChar).Value = dwData["ABJAWERK"].ToString();
                    or1.Parameters.Add("ABJAABT", OracleType.NVarChar).Value = dwData["ABJAABT"].ToString();
                    or1.Parameters.Add("ABJAWAKZ", OracleType.NVarChar).Value = dwData["ABJAWAKZ"].ToString();
                    or1.Parameters.Add("ABJAART", OracleType.NVarChar).Value = dwData["ABJAART"].ToString();
                    or1.Parameters.Add("ABJAVAR", OracleType.NVarChar).Value = dwData["ABJAVAR"].ToString();
                    or1.Parameters.Add("ABJAFARBE", OracleType.NVarChar).Value = dwData["ABJAFARBE"].ToString();
                    or1.Parameters.Add("ABJADESS", OracleType.NVarChar).Value = dwData["ABJADESS"].ToString();
                    or1.Parameters.Add("ABJACOLORIT", OracleType.NVarChar).Value = dwData["ABJACOLORIT"].ToString();
                    or1.Parameters.Add("ABJABESCHICH", OracleType.NVarChar).Value = dwData["ABJABESCHICH"].ToString();
                    or1.Parameters.Add("ABJAZUSTAND", OracleType.NVarChar).Value = dwData["ABJAZUSTAND"].ToString();
                    or1.Parameters.Add("ABJAGROE", OracleType.NVarChar).Value = dwData["ABJAGROE"].ToString();
                    or1.Parameters.Add("ABJASME", OracleType.NVarChar).Value = dwData["ABJASME"].ToString();
                    or1.Parameters.Add("ABJASOLLMENGE1", OracleType.NVarChar).Value = dwData["ABJASOLLMENGE1"].ToString();
                    or1.Parameters.Add("ABJASOLLMENGE2", OracleType.NVarChar).Value = dwData["ABJASOLLMENGE2"].ToString();
                    or1.Parameters.Add("ABJASOLLMENGE3", OracleType.NVarChar).Value = dwData["ABJASOLLMENGE3"].ToString();
                    or1.Parameters.Add("ABJASOLLMENGE4", OracleType.NVarChar).Value = dwData["ABJASOLLMENGE4"].ToString();
                    or1.Parameters.Add("ABJASOLLMENGE5", OracleType.NVarChar).Value = dwData["ABJASOLLMENGE5"].ToString();
                    or1.Parameters.Add("ABJASOLLMENGE6", OracleType.NVarChar).Value = dwData["ABJASOLLMENGE6"].ToString();
                    or1.Parameters.Add("ABJASOLLMENGE7", OracleType.NVarChar).Value = dwData["ABJASOLLMENGE7"].ToString();
                    or1.Parameters.Add("ABJASOLLMENGE8", OracleType.NVarChar).Value = dwData["ABJASOLLMENGE8"].ToString();
                    or1.Parameters.Add("ABJAVLLFM", OracleType.NVarChar).Value = dwData["ABJAVLLFM"].ToString();
                    or1.Parameters.Add("ABJAVLKG", OracleType.NVarChar).Value = dwData["ABJAVLKG"].ToString();
                    or1.Parameters.Add("ABJAVLSTK", OracleType.NVarChar).Value = dwData["ABJAVLSTK"].ToString();
                    or1.Parameters.Add("ABJAEALFM", OracleType.NVarChar).Value = dwData["ABJAEALFM"].ToString();
                    or1.Parameters.Add("ABJAEAKG", OracleType.NVarChar).Value = dwData["ABJAEAKG"].ToString();
                    or1.Parameters.Add("ABJAEASTK", OracleType.NVarChar).Value = dwData["ABJAEASTK"].ToString();
                    or1.Parameters.Add("ABJAEBLFM", OracleType.NVarChar).Value = dwData["ABJAEBLFM"].ToString();
                    or1.Parameters.Add("ABJAEBKG", OracleType.NVarChar).Value = dwData["ABJAEBKG"].ToString();
                    or1.Parameters.Add("ABJAEBSTK", OracleType.NVarChar).Value = dwData["ABJAEBSTK"].ToString();
                    or1.Parameters.Add("ABJAABLFM", OracleType.NVarChar).Value = dwData["ABJAABLFM"].ToString();
                    or1.Parameters.Add("ABJAABKG", OracleType.NVarChar).Value = dwData["ABJAABKG"].ToString();
                    or1.Parameters.Add("ABJAABSTK", OracleType.NVarChar).Value = dwData["ABJAABSTK"].ToString();
                    or1.Parameters.Add("ABJAVSLFM", OracleType.NVarChar).Value = dwData["ABJAVSLFM"].ToString();
                    or1.Parameters.Add("ABJAVSKG", OracleType.NVarChar).Value = dwData["ABJAVSKG"].ToString();
                    or1.Parameters.Add("ABJAVSSTK", OracleType.NVarChar).Value = dwData["ABJAVSSTK"].ToString();
                    or1.Parameters.Add("ABJARTLFM", OracleType.NVarChar).Value = dwData["ABJARTLFM"].ToString();
                    or1.Parameters.Add("ABJARTKG", OracleType.NVarChar).Value = dwData["ABJARTKG"].ToString();
                    or1.Parameters.Add("ABJARTSTK", OracleType.NVarChar).Value = dwData["ABJARTSTK"].ToString();
                    or1.Parameters.Add("ABJAANRKR", OracleType.NVarChar).Value = dwData["ABJAANRKR"].ToString();
                    or1.Parameters.Add("ABJAALFDNR", OracleType.NVarChar).Value = dwData["ABJAALFDNR"].ToString();
                    or1.Parameters.Add("ABJAAFOLGEV", OracleType.NVarChar).Value = dwData["ABJAAFOLGEV"].ToString();
                    or1.Parameters.Add("ABJAAFOLGEB", OracleType.NVarChar).Value = dwData["ABJAAFOLGEB"].ToString();
                    or1.Parameters.Add("ABJAANRKR2", OracleType.NVarChar).Value = dwData["ABJAANRKR2"].ToString();
                    or1.Parameters.Add("ABJAALFDNR2", OracleType.NVarChar).Value = dwData["ABJAALFDNR2"].ToString();
                    or1.Parameters.Add("ABJAAFOLGEV2", OracleType.NVarChar).Value = dwData["ABJAAFOLGEV2"].ToString();
                    or1.Parameters.Add("ABJAAFOLGEB2", OracleType.NVarChar).Value = dwData["ABJAAFOLGEB2"].ToString();
                    or1.Parameters.Add("ABJAANRKR3", OracleType.NVarChar).Value = dwData["ABJAANRKR3"].ToString();
                    or1.Parameters.Add("ABJAALFDNR3", OracleType.NVarChar).Value = dwData["ABJAALFDNR3"].ToString();
                    or1.Parameters.Add("ABJAAFOLGEV3", OracleType.NVarChar).Value = dwData["ABJAAFOLGEV3"].ToString();
                    or1.Parameters.Add("ABJAAFOLGEB3", OracleType.NVarChar).Value = dwData["ABJAAFOLGEB3"].ToString();
                    or1.Parameters.Add("ABJAANRKR4", OracleType.NVarChar).Value = dwData["ABJAANRKR4"].ToString();
                    or1.Parameters.Add("ABJAALFDNR4", OracleType.NVarChar).Value = dwData["ABJAALFDNR4"].ToString();
                    or1.Parameters.Add("ABJAAFOLGEV4", OracleType.NVarChar).Value = dwData["ABJAAFOLGEV4"].ToString();
                    or1.Parameters.Add("ABJAAFOLGEB4", OracleType.NVarChar).Value = dwData["ABJAAFOLGEB4"].ToString();
                    or1.Parameters.Add("ABJAVKAUFTYP", OracleType.NVarChar).Value = dwData["ABJAVKAUFTYP"].ToString();
                    or1.Parameters.Add("ABJAVKAUFKRS", OracleType.NVarChar).Value = dwData["ABJAVKAUFKRS"].ToString();
                    or1.Parameters.Add("ABJAVKAUFLFD", OracleType.NVarChar).Value = dwData["ABJAVKAUFLFD"].ToString();
                    or1.Parameters.Add("ABJAVKAUFPOS", OracleType.NVarChar).Value = dwData["ABJAVKAUFPOS"].ToString();
                    or1.Parameters.Add("ABJAVORMKZ", OracleType.NVarChar).Value = dwData["ABJAVORMKZ"].ToString();
                    or1.Parameters.Add("ABJASANZSTK", OracleType.NVarChar).Value = dwData["ABJASANZSTK"].ToString();
                    or1.Parameters.Add("ABJASSTKLG", OracleType.NVarChar).Value = dwData["ABJASSTKLG"].ToString();
                    or1.Parameters.Add("ABJASSTKGEW", OracleType.NVarChar).Value = dwData["ABJASSTKGEW"].ToString();
                    or1.Parameters.Add("ABJASSTKBRT", OracleType.NVarChar).Value = dwData["ABJASSTKBRT"].ToString();
                    or1.Parameters.Add("ABJAGENDAT", OracleType.NVarChar).Value = dwData["ABJAGENDAT"].ToString();
                    or1.Parameters.Add("ABJAGENNR", OracleType.NVarChar).Value = dwData["ABJAGENNR"].ToString();
                    or1.Parameters.Add("ABJAGENNAME", OracleType.NVarChar).Value = dwData["ABJAGENNAME"].ToString();
                    or1.Parameters.Add("ABJAGENWEG", OracleType.NVarChar).Value = dwData["ABJAGENWEG"].ToString();
                    or1.Parameters.Add("ABJFILLER2", OracleType.NVarChar).Value = dwData["ABJFILLER2"].ToString();
                    or1.Parameters.Add("ABJNSTATUS", OracleType.NVarChar).Value = dwData["ABJNSTATUS"].ToString();
                    or1.Parameters.Add("ABJNSPGRD", OracleType.NVarChar).Value = dwData["ABJNSPGRD"].ToString();
                    or1.Parameters.Add("ABJNKUNDNR", OracleType.NVarChar).Value = dwData["ABJNKUNDNR"].ToString();
                    or1.Parameters.Add("ABJNWERK", OracleType.NVarChar).Value = dwData["ABJNWERK"].ToString();
                    or1.Parameters.Add("ABJNABT", OracleType.NVarChar).Value = dwData["ABJNABT"].ToString();
                    or1.Parameters.Add("ABJNWAKZ", OracleType.NVarChar).Value = dwData["ABJNWAKZ"].ToString();
                    or1.Parameters.Add("ABJNART", OracleType.NVarChar).Value = dwData["ABJNART"].ToString();
                    or1.Parameters.Add("ABJNVAR", OracleType.NVarChar).Value = dwData["ABJNVAR"].ToString();
                    or1.Parameters.Add("ABJNFARBE", OracleType.NVarChar).Value = dwData["ABJNFARBE"].ToString();
                    or1.Parameters.Add("ABJNDESS", OracleType.NVarChar).Value = dwData["ABJNDESS"].ToString();
                    or1.Parameters.Add("ABJNCOLORIT", OracleType.NVarChar).Value = dwData["ABJNCOLORIT"].ToString();
                    or1.Parameters.Add("ABJNBESCHICH", OracleType.NVarChar).Value = dwData["ABJNBESCHICH"].ToString();
                    or1.Parameters.Add("ABJNZUSTAND", OracleType.NVarChar).Value = dwData["ABJNZUSTAND"].ToString();
                    or1.Parameters.Add("ABJNGROE", OracleType.NVarChar).Value = dwData["ABJNGROE"].ToString();
                    or1.Parameters.Add("ABJNSME", OracleType.NVarChar).Value = dwData["ABJNSME"].ToString();
                    or1.Parameters.Add("ABJNSOLLMENGE1", OracleType.NVarChar).Value = dwData["ABJNSOLLMENGE1"].ToString();
                    or1.Parameters.Add("ABJNSOLLMENGE2", OracleType.NVarChar).Value = dwData["ABJNSOLLMENGE2"].ToString();
                    or1.Parameters.Add("ABJNSOLLMENGE3", OracleType.NVarChar).Value = dwData["ABJNSOLLMENGE3"].ToString();
                    or1.Parameters.Add("ABJNSOLLMENGE4", OracleType.NVarChar).Value = dwData["ABJNSOLLMENGE4"].ToString();
                    or1.Parameters.Add("ABJNSOLLMENGE5", OracleType.NVarChar).Value = dwData["ABJNSOLLMENGE5"].ToString();
                    or1.Parameters.Add("ABJNSOLLMENGE6", OracleType.NVarChar).Value = dwData["ABJNSOLLMENGE6"].ToString();
                    or1.Parameters.Add("ABJNSOLLMENGE7", OracleType.NVarChar).Value = dwData["ABJNSOLLMENGE7"].ToString();
                    or1.Parameters.Add("ABJNSOLLMENGE8", OracleType.NVarChar).Value = dwData["ABJNSOLLMENGE8"].ToString();
                    or1.Parameters.Add("ABJNVLLFM", OracleType.NVarChar).Value = dwData["ABJNVLLFM"].ToString();
                    or1.Parameters.Add("ABJNVLKG", OracleType.NVarChar).Value = dwData["ABJNVLKG"].ToString();
                    or1.Parameters.Add("ABJNVLSTK", OracleType.NVarChar).Value = dwData["ABJNVLSTK"].ToString();
                    or1.Parameters.Add("ABJNEALFM", OracleType.NVarChar).Value = dwData["ABJNEALFM"].ToString();
                    or1.Parameters.Add("ABJNEAKG", OracleType.NVarChar).Value = dwData["ABJNEAKG"].ToString();
                    or1.Parameters.Add("ABJNEASTK", OracleType.NVarChar).Value = dwData["ABJNEASTK"].ToString();
                    or1.Parameters.Add("ABJNEBLFM", OracleType.NVarChar).Value = dwData["ABJNEBLFM"].ToString();
                    or1.Parameters.Add("ABJNEBKG", OracleType.NVarChar).Value = dwData["ABJNEBKG"].ToString();
                    or1.Parameters.Add("ABJNEBSTK", OracleType.NVarChar).Value = dwData["ABJNEBSTK"].ToString();
                    or1.Parameters.Add("ABJNABLFM", OracleType.NVarChar).Value = dwData["ABJNABLFM"].ToString();
                    or1.Parameters.Add("ABJNABKG", OracleType.NVarChar).Value = dwData["ABJNABKG"].ToString();
                    or1.Parameters.Add("ABJNABSTK", OracleType.NVarChar).Value = dwData["ABJNABSTK"].ToString();
                    or1.Parameters.Add("ABJNVSLFM", OracleType.NVarChar).Value = dwData["ABJNVSLFM"].ToString();
                    or1.Parameters.Add("ABJNVSKG", OracleType.NVarChar).Value = dwData["ABJNVSKG"].ToString();
                    or1.Parameters.Add("ABJNVSSTK", OracleType.NVarChar).Value = dwData["ABJNVSSTK"].ToString();
                    or1.Parameters.Add("ABJNRTLFM", OracleType.NVarChar).Value = dwData["ABJNRTLFM"].ToString();
                    or1.Parameters.Add("ABJNRTKG", OracleType.NVarChar).Value = dwData["ABJNRTKG"].ToString();
                    or1.Parameters.Add("ABJNRTSTK", OracleType.NVarChar).Value = dwData["ABJNRTSTK"].ToString();
                    or1.Parameters.Add("ABJNANRKR", OracleType.NVarChar).Value = dwData["ABJNANRKR"].ToString();
                    or1.Parameters.Add("ABJNALFDNR", OracleType.NVarChar).Value = dwData["ABJNALFDNR"].ToString();
                    or1.Parameters.Add("ABJNAFOLGEV", OracleType.NVarChar).Value = dwData["ABJNAFOLGEV"].ToString();
                    or1.Parameters.Add("ABJNAFOLGEB", OracleType.NVarChar).Value = dwData["ABJNAFOLGEB"].ToString();
                    or1.Parameters.Add("ABJNANRKR2", OracleType.NVarChar).Value = dwData["ABJNANRKR2"].ToString();
                    or1.Parameters.Add("ABJNALFDNR2", OracleType.NVarChar).Value = dwData["ABJNALFDNR2"].ToString();
                    or1.Parameters.Add("ABJNAFOLGEV2", OracleType.NVarChar).Value = dwData["ABJNAFOLGEV2"].ToString();
                    or1.Parameters.Add("ABJNAFOLGEB2", OracleType.NVarChar).Value = dwData["ABJNAFOLGEB2"].ToString();
                    or1.Parameters.Add("ABJNANRKR3", OracleType.NVarChar).Value = dwData["ABJNANRKR3"].ToString();
                    or1.Parameters.Add("ABJNALFDNR3", OracleType.NVarChar).Value = dwData["ABJNALFDNR3"].ToString();
                    or1.Parameters.Add("ABJNAFOLGEV3", OracleType.NVarChar).Value = dwData["ABJNAFOLGEV3"].ToString();
                    or1.Parameters.Add("ABJNAFOLGEB3", OracleType.NVarChar).Value = dwData["ABJNAFOLGEB3"].ToString();
                    or1.Parameters.Add("ABJNANRKR4", OracleType.NVarChar).Value = dwData["ABJNANRKR4"].ToString();
                    or1.Parameters.Add("ABJNALFDNR4", OracleType.NVarChar).Value = dwData["ABJNALFDNR4"].ToString();
                    or1.Parameters.Add("ABJNAFOLGEV4", OracleType.NVarChar).Value = dwData["ABJNAFOLGEV4"].ToString();
                    or1.Parameters.Add("ABJNAFOLGEB4", OracleType.NVarChar).Value = dwData["ABJNAFOLGEB4"].ToString();
                    or1.Parameters.Add("ABJNVKAUFTYP", OracleType.NVarChar).Value = dwData["ABJNVKAUFTYP"].ToString();
                    or1.Parameters.Add("ABJNVKAUFKRS", OracleType.NVarChar).Value = dwData["ABJNVKAUFKRS"].ToString();
                    or1.Parameters.Add("ABJNVKAUFLFD", OracleType.NVarChar).Value = dwData["ABJNVKAUFLFD"].ToString();
                    or1.Parameters.Add("ABJNVKAUFPOS", OracleType.NVarChar).Value = dwData["ABJNVKAUFPOS"].ToString();
                    or1.Parameters.Add("ABJNVORMKZ", OracleType.NVarChar).Value = dwData["ABJNVORMKZ"].ToString();
                    or1.Parameters.Add("ABJNSANZSTK", OracleType.NVarChar).Value = dwData["ABJNSANZSTK"].ToString();
                    or1.Parameters.Add("ABJNSSTKLG", OracleType.NVarChar).Value = dwData["ABJNSSTKLG"].ToString();
                    or1.Parameters.Add("ABJNSSTKGEW", OracleType.NVarChar).Value = dwData["ABJNSSTKGEW"].ToString();
                    or1.Parameters.Add("ABJNSSTKBRT", OracleType.NVarChar).Value = dwData["ABJNSSTKBRT"].ToString();
                    or1.Parameters.Add("ABJNGENDAT", OracleType.NVarChar).Value = dwData["ABJNGENDAT"].ToString();
                    or1.Parameters.Add("ABJNGENNR", OracleType.NVarChar).Value = dwData["ABJNGENNR"].ToString();
                    or1.Parameters.Add("ABJNGENNAME", OracleType.NVarChar).Value = dwData["ABJNGENNAME"].ToString();
                    or1.Parameters.Add("ABJNGENWEG", OracleType.NVarChar).Value = dwData["ABJNGENWEG"].ToString();
                    or1.Parameters.Add("ABJFILLER3", OracleType.NVarChar).Value = dwData["ABJFILLER3"].ToString();
                    #endregion
                    break;
                default:
                    break;
            }


            Connect2Proxy(or1);
        }
    }
}
